/*
 Navicat Premium Data Transfer

 Source Server         : distributed-mail
 Source Server Type    : MySQL
 Source Server Version : 50740
 Source Host           : 43.140.208.238:3306
 Source Schema         : distributed-mail

 Target Server Type    : MySQL
 Target Server Version : 50740
 File Encoding         : 65001

 Date: 10/11/2023 19:45:56
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for QRTZ_BLOB_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_BLOB_TRIGGERS`;
CREATE TABLE `QRTZ_BLOB_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(190) NOT NULL,
  `TRIGGER_GROUP` varchar(190) NOT NULL,
  `BLOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_BLOB_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_CALENDARS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_CALENDARS`;
CREATE TABLE `QRTZ_CALENDARS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `CALENDAR_NAME` varchar(190) NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_CRON_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_CRON_TRIGGERS`;
CREATE TABLE `QRTZ_CRON_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(190) NOT NULL,
  `TRIGGER_GROUP` varchar(190) NOT NULL,
  `CRON_EXPRESSION` varchar(120) NOT NULL,
  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_CRON_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of QRTZ_CRON_TRIGGERS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('QuartzScheduler', '54', '2295908251@qq.com', '0 0 8 * * ?', 'Asia/Shanghai');
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('QuartzScheduler', '55', '2295908251@qq.com', '0 0 0 1 * ?', 'Asia/Shanghai');
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('QuartzScheduler', '60', '2295908251@qq.com', '0 0 2 1 * ?', 'Asia/Shanghai');
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('QuartzScheduler', '61', '2295908251@qq.com', '0 0 19 * * ?', 'Asia/Shanghai');
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('QuartzScheduler', '62', '2295908251@qq.com', '0 50 19 * * ?', 'Asia/Shanghai');
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('QuartzScheduler', '65', '2295908251@qq.com', '0 0 8 * * ?', 'Asia/Shanghai');
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('QuartzScheduler', '67', '2295908251@qq.com', '0 0 0 * * ?', 'Asia/Shanghai');
INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('QuartzScheduler', '68', '2728771838@qq.com', '0 26 10 * * ?', 'Asia/Shanghai');
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_FIRED_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_FIRED_TRIGGERS`;
CREATE TABLE `QRTZ_FIRED_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `ENTRY_ID` varchar(95) NOT NULL,
  `TRIGGER_NAME` varchar(190) NOT NULL,
  `TRIGGER_GROUP` varchar(190) NOT NULL,
  `INSTANCE_NAME` varchar(190) NOT NULL,
  `FIRED_TIME` bigint(13) NOT NULL,
  `SCHED_TIME` bigint(13) NOT NULL,
  `PRIORITY` int(11) NOT NULL,
  `STATE` varchar(16) NOT NULL,
  `JOB_NAME` varchar(190) DEFAULT NULL,
  `JOB_GROUP` varchar(190) DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`),
  KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`),
  KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_JOB_DETAILS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_JOB_DETAILS`;
CREATE TABLE `QRTZ_JOB_DETAILS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `JOB_NAME` varchar(190) NOT NULL,
  `JOB_GROUP` varchar(190) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) NOT NULL,
  `IS_DURABLE` varchar(1) NOT NULL,
  `IS_NONCONCURRENT` varchar(1) NOT NULL,
  `IS_UPDATE_DATA` varchar(1) NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of QRTZ_JOB_DETAILS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('QuartzScheduler', '54', '2295908251@qq.com', NULL, 'com.mail.job.SendEmailJob', '1', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C77080000001000000001740005656D61696C73720019636F6D2E6D61696C2E64746F2E53656E64456D61696C44746F000000000000000102000A4C0007636F6E74656E747400124C6A6176612F6C616E672F537472696E673B4C000566696C65737400314C6F72672F737072696E676672616D65776F726B2F7765622F6D756C7469706172742F4D756C74697061727446696C653B4C0004706F727471007E00095B000B726563656976654D61696C7400135B4C6A6176612F6C616E672F537472696E673B4C000F726563656976654D61696C4E616D6571007E00094C000873656E644D61696C71007E00094C000C73656E644D61696C4E616D6571007E00094C000B73656E644D61696C50776471007E00094C000C73656E64534D5450486F737471007E00094C00057469746C6571007E00097870740030E697A9E4B88AE5A5BDEFBC81E4BB8AE5A4A9E4B99FE698AFE58583E6B094E6BBA1E6BBA1E79A84E4B880E5A4A9EFBC8170740003343635757200135B4C6A6176612E6C616E672E537472696E673BADD256E7E91D7B47020000787000000001740011323239353930383235314071712E636F6D740015E99D92E982AE726563656976654D61696C4E616D65740011323239353930383235314071712E636F6D740006E998BFE6B3BD740010716169667372627877626B7A646A686274000B736D74702E71712E636F6D740012E697A9E4B88AE5A5BDEFBC81E998BFE6B3BD7800);
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('QuartzScheduler', '55', '2295908251@qq.com', NULL, 'com.mail.job.SendEmailJob', '1', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C77080000001000000001740005656D61696C73720019636F6D2E6D61696C2E64746F2E53656E64456D61696C44746F000000000000000102000A4C0007636F6E74656E747400124C6A6176612F6C616E672F537472696E673B4C000566696C65737400314C6F72672F737072696E676672616D65776F726B2F7765622F6D756C7469706172742F4D756C74697061727446696C653B4C0004706F727471007E00095B000B726563656976654D61696C7400135B4C6A6176612F6C616E672F537472696E673B4C000F726563656976654D61696C4E616D6571007E00094C000873656E644D61696C71007E00094C000C73656E644D61696C4E616D6571007E00094C000B73656E644D61696C50776471007E00094C000C73656E64534D5450486F737471007E00094C00057469746C6571007E00097870740024E5BFABE99DA2E8AF95E4BA86EFBC8CE58AA0E6B2B9E58AA0E6B2B9EFBC81EFBC81EFBC8170740003343635757200135B4C6A6176612E6C616E672E537472696E673BADD256E7E91D7B47020000787000000002740011323239353930383235314071712E636F6D740011323639303537343334314071712E636F6D740015E99D92E982AE726563656976654D61696C4E616D65740011323239353930383235314071712E636F6D740006E99D92E982AE740010716169667372627877626B7A646A686274000B736D74702E71712E636F6D74000CE6AF8FE69C88E68F90E986927800);
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('QuartzScheduler', '60', '2295908251@qq.com', NULL, 'com.mail.job.SendEmailJob', '1', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C77080000001000000001740005656D61696C73720019636F6D2E6D61696C2E64746F2E53656E64456D61696C44746F000000000000000102000A4C0007636F6E74656E747400124C6A6176612F6C616E672F537472696E673B4C000566696C65737400314C6F72672F737072696E676672616D65776F726B2F7765622F6D756C7469706172742F4D756C74697061727446696C653B4C0004706F727471007E00095B000B726563656976654D61696C7400135B4C6A6176612F6C616E672F537472696E673B4C000F726563656976654D61696C4E616D6571007E00094C000873656E644D61696C71007E00094C000C73656E644D61696C4E616D6571007E00094C000B73656E644D61696C50776471007E00094C000C73656E64534D5450486F737471007E00094C00057469746C6571007E00097870740018797379E78BACE7BE8EE79A84E982AEE4BBB6E6ADA3E6968770740003343635757200135B4C6A6176612E6C616E672E537472696E673BADD256E7E91D7B47020000787000000001740011323239353930383235314071712E636F6D740015E99D92E982AE726563656976654D61696C4E616D65740011323239353930383235314071712E636F6D740006E99D92E982AE740010716169667372627877626B7A646A686274000B736D74702E71712E636F6D740012797379E78BACE7BE8EE79A84E982AEE4BBB67800);
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('QuartzScheduler', '61', '2295908251@qq.com', NULL, 'com.mail.job.SendEmailJob', '1', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C77080000001000000001740005656D61696C73720019636F6D2E6D61696C2E64746F2E53656E64456D61696C44746F000000000000000102000A4C0007636F6E74656E747400124C6A6176612F6C616E672F537472696E673B4C000566696C65737400314C6F72672F737072696E676672616D65776F726B2F7765622F6D756C7469706172742F4D756C74697061727446696C653B4C0004706F727471007E00095B000B726563656976654D61696C7400135B4C6A6176612F6C616E672F537472696E673B4C000F726563656976654D61696C4E616D6571007E00094C000873656E644D61696C71007E00094C000C73656E644D61696C4E616D6571007E00094C000B73656E644D61696C50776471007E00094C000C73656E64534D5450486F737471007E00094C00057469746C6571007E00097870740026E8BF98E69C893130E58886E9929FE4B88AE78FADEFBC8CE68A93E7B4A7E697B6E997B4E4BA8670740003343635757200135B4C6A6176612E6C616E672E537472696E673BADD256E7E91D7B470200007870000000017400103239353930383235314071712E636F6D740015E99D92E982AE726563656976654D61696C4E616D65740011323239353930383235314071712E636F6D740006E99D92E982AE740010716169667372627877626B7A646A686274000B736D74702E71712E636F6D74000CE4B88AE78FADE68F90E986927800);
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('QuartzScheduler', '62', '2295908251@qq.com', NULL, 'com.mail.job.SendEmailJob', '1', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C77080000001000000001740005656D61696C73720019636F6D2E6D61696C2E64746F2E53656E64456D61696C44746F000000000000000102000A4C0007636F6E74656E747400124C6A6176612F6C616E672F537472696E673B4C000566696C65737400314C6F72672F737072696E676672616D65776F726B2F7765622F6D756C7469706172742F4D756C74697061727446696C653B4C0004706F727471007E00095B000B726563656976654D61696C7400135B4C6A6176612F6C616E672F537472696E673B4C000F726563656976654D61696C4E616D6571007E00094C000873656E644D61696C71007E00094C000C73656E644D61696C4E616D6571007E00094C000B73656E644D61696C50776471007E00094C000C73656E64534D5450486F737471007E00094C00057469746C6571007E00097870740026E8BF98E69C893130E58886E9929FE4B88AE78FADEFBC8CE68A93E7B4A7E697B6E997B4E4BA8670740003343635757200135B4C6A6176612E6C616E672E537472696E673BADD256E7E91D7B47020000787000000001740011323239353930383235314071712E636F6D740015E99D92E982AE726563656976654D61696C4E616D65740011323239353930383235314071712E636F6D740006E99D92E982AE740010716169667372627877626B7A646A686274000B736D74702E71712E636F6D740026E8BF98E69C893130E58886E9929FE4B88AE78FADEFBC8CE68A93E7B4A7E697B6E997B4E4BA867800);
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('QuartzScheduler', '65', '2295908251@qq.com', NULL, 'com.mail.job.SendEmailJob', '1', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C77080000001000000001740005656D61696C73720019636F6D2E6D61696C2E64746F2E53656E64456D61696C44746F000000000000000102000A4C0007636F6E74656E747400124C6A6176612F6C616E672F537472696E673B4C000566696C65737400314C6F72672F737072696E676672616D65776F726B2F7765622F6D756C7469706172742F4D756C74697061727446696C653B4C0004706F727471007E00095B000B726563656976654D61696C7400135B4C6A6176612F6C616E672F537472696E673B4C000F726563656976654D61696C4E616D6571007E00094C000873656E644D61696C71007E00094C000C73656E644D61696C4E616D6571007E00094C000B73656E644D61696C50776471007E00094C000C73656E64534D5450486F737471007E00094C00057469746C6571007E0009787074003CE4BB8AE5A4A9E4B99FE8A681E5A5BDE5A5BDE5ADA6E4B9A0EFBC8CE697A9E782B9E4BC91E681AFEFBC8CE994BBE782BCE8BAABE4BD93E593A67E7E7E70740003343635757200135B4C6A6176612E6C616E672E537472696E673BADD256E7E91D7B47020000787000000002740011323732383737313833384071712E636F6D740011323239353930383235314071712E636F6D740006E99D92E982AE740011323239353930383235314071712E636F6D740006E998BFE6B3BD740010716169667372627877626B7A646A686274000B736D74702E71712E636F6D74001EE78999E78999E5928CE6B3BDE6B3BDE79A84E6AF8FE697A5E68F90E986927800);
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('QuartzScheduler', '67', '2295908251@qq.com', NULL, 'com.mail.job.SendEmailJob', '1', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C77080000001000000001740005656D61696C73720019636F6D2E6D61696C2E64746F2E53656E64456D61696C44746F000000000000000102000A4C0007636F6E74656E747400124C6A6176612F6C616E672F537472696E673B4C000566696C65737400314C6F72672F737072696E676672616D65776F726B2F7765622F6D756C7469706172742F4D756C74697061727446696C653B4C0004706F727471007E00095B000B726563656976654D61696C7400135B4C6A6176612F6C616E672F537472696E673B4C000F726563656976654D61696C4E616D6571007E00094C000873656E644D61696C71007E00094C000C73656E644D61696C4E616D6571007E00094C000B73656E644D61696C50776471007E00094C000C73656E64534D5450486F737471007E00094C00057469746C6571007E00097870740019E68891E698AFE4B880E4B8AAE6A8A1E69DBFE6A087E9A2983370740003343635757200135B4C6A6176612E6C616E672E537472696E673BADD256E7E91D7B47020000787000000003740011323239353930383235314071712E636F6D7400103138393537323039344071712E636F6D740011323639303537343334314071712E636F6D740006E99D92E982AE740011323239353930383235314071712E636F6D740006E99D92E982AE740010716169667372627877626B7A646A686274000B736D74702E71712E636F6D740019E68891E698AFE4B880E4B8AAE6A8A1E69DBFE6A087E9A298337800);
INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('QuartzScheduler', '68', '2728771838@qq.com', NULL, 'com.mail.job.SendEmailJob', '1', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C77080000001000000001740005656D61696C73720019636F6D2E6D61696C2E64746F2E53656E64456D61696C44746F000000000000000102000A4C0007636F6E74656E747400124C6A6176612F6C616E672F537472696E673B4C000566696C65737400314C6F72672F737072696E676672616D65776F726B2F7765622F6D756C7469706172742F4D756C74697061727446696C653B4C0004706F727471007E00095B000B726563656976654D61696C7400135B4C6A6176612F6C616E672F537472696E673B4C000F726563656976654D61696C4E616D6571007E00094C000873656E644D61696C71007E00094C000C73656E644D61696C4E616D6571007E00094C000B73656E644D61696C50776471007E00094C000C73656E64534D5450486F737471007E00094C00057469746C6571007E00097870740003777A7A70740003343635757200135B4C6A6176612E6C616E672E537472696E673BADD256E7E91D7B47020000787000000001740011323239353930383235314071712E636F6D740006E99D92E982AE740011323732383737313833384071712E636F6D740006E5B08FE78E8B740010656F647371656A746E62756C6464696774000B736D74702E71712E636F6D740003777A7A7800);
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_LOCKS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_LOCKS`;
CREATE TABLE `QRTZ_LOCKS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `LOCK_NAME` varchar(40) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of QRTZ_LOCKS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_LOCKS` VALUES ('QuartzScheduler', 'STATE_ACCESS');
INSERT INTO `QRTZ_LOCKS` VALUES ('QuartzScheduler', 'TRIGGER_ACCESS');
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_PAUSED_TRIGGER_GRPS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_PAUSED_TRIGGER_GRPS`;
CREATE TABLE `QRTZ_PAUSED_TRIGGER_GRPS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_GROUP` varchar(190) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_SCHEDULER_STATE
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SCHEDULER_STATE`;
CREATE TABLE `QRTZ_SCHEDULER_STATE` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `INSTANCE_NAME` varchar(190) NOT NULL,
  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of QRTZ_SCHEDULER_STATE
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_SCHEDULER_STATE` VALUES ('QuartzScheduler', '1002deMacBook-Air.local1699531286208', 1699532201194, 10000);
COMMIT;

-- ----------------------------
-- Table structure for QRTZ_SIMPLE_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SIMPLE_TRIGGERS`;
CREATE TABLE `QRTZ_SIMPLE_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(190) NOT NULL,
  `TRIGGER_GROUP` varchar(190) NOT NULL,
  `REPEAT_COUNT` bigint(7) NOT NULL,
  `REPEAT_INTERVAL` bigint(12) NOT NULL,
  `TIMES_TRIGGERED` bigint(10) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_SIMPLE_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_SIMPROP_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_SIMPROP_TRIGGERS`;
CREATE TABLE `QRTZ_SIMPROP_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(190) NOT NULL,
  `TRIGGER_GROUP` varchar(190) NOT NULL,
  `STR_PROP_1` varchar(512) DEFAULT NULL,
  `STR_PROP_2` varchar(512) DEFAULT NULL,
  `STR_PROP_3` varchar(512) DEFAULT NULL,
  `INT_PROP_1` int(11) DEFAULT NULL,
  `INT_PROP_2` int(11) DEFAULT NULL,
  `LONG_PROP_1` bigint(20) DEFAULT NULL,
  `LONG_PROP_2` bigint(20) DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `QRTZ_SIMPROP_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for QRTZ_TRIGGERS
-- ----------------------------
DROP TABLE IF EXISTS `QRTZ_TRIGGERS`;
CREATE TABLE `QRTZ_TRIGGERS` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(190) NOT NULL,
  `TRIGGER_GROUP` varchar(190) NOT NULL,
  `JOB_NAME` varchar(190) NOT NULL,
  `JOB_GROUP` varchar(190) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) NOT NULL,
  `TRIGGER_TYPE` varchar(8) NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) DEFAULT NULL,
  `CALENDAR_NAME` varchar(190) DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`),
  KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  CONSTRAINT `QRTZ_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `QRTZ_JOB_DETAILS` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of QRTZ_TRIGGERS
-- ----------------------------
BEGIN;
INSERT INTO `QRTZ_TRIGGERS` VALUES ('QuartzScheduler', '54', '2295908251@qq.com', '54', '2295908251@qq.com', NULL, 1698969600000, 1698890355848, 5, 'PAUSED', 'CRON', 1698303977000, 0, NULL, 0, '');
INSERT INTO `QRTZ_TRIGGERS` VALUES ('QuartzScheduler', '55', '2295908251@qq.com', '55', '2295908251@qq.com', NULL, 1698768000000, -1, 5, 'PAUSED', 'CRON', 1698322334000, 0, NULL, 0, '');
INSERT INTO `QRTZ_TRIGGERS` VALUES ('QuartzScheduler', '60', '2295908251@qq.com', '60', '2295908251@qq.com', NULL, 1701367200000, 1698890355637, 5, 'PAUSED', 'CRON', 1698496053000, 0, NULL, 0, '');
INSERT INTO `QRTZ_TRIGGERS` VALUES ('QuartzScheduler', '61', '2295908251@qq.com', '61', '2295908251@qq.com', NULL, 1699614000000, 1699531291992, 5, 'WAITING', 'CRON', 1698676518000, 0, NULL, 0, '');
INSERT INTO `QRTZ_TRIGGERS` VALUES ('QuartzScheduler', '62', '2295908251@qq.com', '62', '2295908251@qq.com', NULL, 1699617000000, 1699531292244, 5, 'WAITING', 'CRON', 1698676564000, 0, NULL, 0, '');
INSERT INTO `QRTZ_TRIGGERS` VALUES ('QuartzScheduler', '65', '2295908251@qq.com', '65', '2295908251@qq.com', NULL, 1699574400000, 1699531292453, 5, 'WAITING', 'CRON', 1698935546000, 0, NULL, 0, '');
INSERT INTO `QRTZ_TRIGGERS` VALUES ('QuartzScheduler', '67', '2295908251@qq.com', '67', '2295908251@qq.com', NULL, 1699113600000, -1, 5, 'PAUSED', 'CRON', 1699060882000, 0, NULL, 0, '');
INSERT INTO `QRTZ_TRIGGERS` VALUES ('QuartzScheduler', '68', '2728771838@qq.com', '68', '2728771838@qq.com', NULL, 1699583160000, 1699531291695, 5, 'WAITING', 'CRON', 1699064684000, 0, NULL, 0, '');
COMMIT;

-- ----------------------------
-- Table structure for email_config
-- ----------------------------
DROP TABLE IF EXISTS `email_config`;
CREATE TABLE `email_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(11) DEFAULT NULL COMMENT '用户id',
  `account_email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `email_type` int(255) DEFAULT NULL COMMENT '0qq/1网易',
  `email_key` varchar(255) DEFAULT NULL COMMENT '密钥',
  `email_port` varchar(20) DEFAULT NULL COMMENT '发送端口号',
  `send_host` varchar(20) DEFAULT NULL COMMENT 'smtp.qq.com',
  `create_user` bigint(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint(20) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of email_config
-- ----------------------------
BEGIN;
INSERT INTO `email_config` VALUES (8, 3, '2728771838@qq.com', 0, 'eodsqejtnbulddig', '465', 'smtp.qq.com', NULL, '2023-10-12 20:10:43', NULL, '2023-10-12 20:10:43');
INSERT INTO `email_config` VALUES (17, 5, '2295908251@qq.com', 0, 'qaifsrbxwbkzdjhb', '465', 'smtp.qq.com', NULL, '2023-10-26 15:04:41', NULL, '2023-10-26 15:04:41');
COMMIT;

-- ----------------------------
-- Table structure for email_team
-- ----------------------------
DROP TABLE IF EXISTS `email_team`;
CREATE TABLE `email_team` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `team_name` varchar(255) DEFAULT NULL COMMENT '团队名称',
  `team_manager` bigint(20) DEFAULT NULL COMMENT '团队管理员',
  `team_notes` varchar(255) DEFAULT NULL COMMENT '团队备注',
  `create_time` datetime DEFAULT NULL COMMENT '团队创建时间',
  `create_user` bigint(255) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_user` bigint(20) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of email_team
-- ----------------------------
BEGIN;
INSERT INTO `email_team` VALUES (1, 'ysy独美', 3, 'ysy独美', '2023-10-25 21:53:39', NULL, '2023-10-25 21:53:39', NULL);
INSERT INTO `email_team` VALUES (2, 'wzz的1团队', 5, 'wzz的第一个团队介绍', '2023-10-26 14:55:39', NULL, '2023-10-26 14:55:39', NULL);
INSERT INTO `email_team` VALUES (3, 'wzz团队2', 5, 'wzz团队2', '2023-10-30 22:32:49', NULL, '2023-10-30 22:32:49', NULL);
INSERT INTO `email_team` VALUES (4, 'wzz最帅', 3, 'wzz', '2023-11-04 10:35:00', NULL, '2023-11-04 10:35:00', NULL);
COMMIT;

-- ----------------------------
-- Table structure for email_templates
-- ----------------------------
DROP TABLE IF EXISTS `email_templates`;
CREATE TABLE `email_templates` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  `email_title` varchar(255) DEFAULT NULL COMMENT '邮件标题',
  `email_content` text COMMENT '邮件内容',
  `person_or_team` int(255) DEFAULT NULL COMMENT '个人为0团队为1',
  `team_id` bigint(20) DEFAULT NULL COMMENT '团队id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_user` bigint(255) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_user` bigint(20) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of email_templates
-- ----------------------------
BEGIN;
INSERT INTO `email_templates` VALUES (2, 2, '432', '热', 0, NULL, '2023-10-05 15:04:54', NULL, '2023-10-05 15:04:54', NULL);
INSERT INTO `email_templates` VALUES (3, 2, '你好4', '哈哈哈4', 0, 1, '2023-10-05 15:07:12', NULL, '2023-10-05 15:07:12', NULL);
INSERT INTO `email_templates` VALUES (5, 1, '你好', '你好', 0, NULL, '2023-10-05 15:07:15', NULL, '2023-10-05 15:07:15', NULL);
INSERT INTO `email_templates` VALUES (13, 5, '我是一个模板标题', '我是一个模板内容', 0, NULL, '2023-10-26 15:05:05', NULL, '2023-10-26 15:05:05', NULL);
INSERT INTO `email_templates` VALUES (14, 5, 'www4', '4234', 0, NULL, '2023-10-28 20:33:26', NULL, '2023-10-28 20:33:26', NULL);
INSERT INTO `email_templates` VALUES (15, 5, '我是一个模板标题2', '我是一个模板标题2', 0, NULL, '2023-10-28 20:33:35', NULL, '2023-10-28 20:33:35', NULL);
INSERT INTO `email_templates` VALUES (16, 5, '我是一个模板标题4', '我是一个模板标题4', 0, NULL, '2023-10-28 20:33:41', NULL, '2023-10-28 20:33:41', NULL);
INSERT INTO `email_templates` VALUES (17, 5, '我是一个模板标题3', '我是一个模板标题3', 0, NULL, '2023-10-28 20:33:47', NULL, '2023-10-28 20:33:47', NULL);
INSERT INTO `email_templates` VALUES (18, 5, '我是一个模板标题6', '我是一个模板标题6', 0, NULL, '2023-10-28 20:33:53', NULL, '2023-10-28 20:33:53', NULL);
COMMIT;

-- ----------------------------
-- Table structure for mail
-- ----------------------------
DROP TABLE IF EXISTS `mail`;
CREATE TABLE `mail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `account_email` varchar(25) NOT NULL COMMENT '邮箱',
  `email_type` varchar(255) DEFAULT NULL COMMENT '0qq/1网易',
  `title` varchar(255) DEFAULT NULL COMMENT '邮件标题',
  `email_content` text COMMENT '邮件发送内容',
  `regular_time` varchar(67) DEFAULT NULL COMMENT '定时发送时间',
  `to_mail` varchar(255) NOT NULL COMMENT '接收人',
  `person_or_team` varchar(255) DEFAULT NULL COMMENT '个人为0团队为1',
  `team_id` bigint(20) DEFAULT NULL COMMENT '团队id',
  `send_mail_name` varchar(255) DEFAULT NULL COMMENT '发件人名称',
  `receive_mail_name` varchar(255) DEFAULT NULL COMMENT '收件人昵称(可选)',
  `status` varchar(255) DEFAULT '0' COMMENT '0正在运行，1暂停',
  `create_user` bigint(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_user` bigint(20) DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of mail
-- ----------------------------
BEGIN;
INSERT INTO `mail` VALUES (54, 5, '2295908251@qq.com', NULL, '早上好！阿泽', '早上好！今天也是元气满满的一天！', '0 0 8 * * ?', '2295908251@qq.com', '0', NULL, '阿泽', '青邮receiveMailName', '1', NULL, '2023-10-26 15:06:18', NULL, '2023-10-26 15:06:18');
INSERT INTO `mail` VALUES (55, 5, '2295908251@qq.com', NULL, '每月提醒', '快面试了，加油加油！！！', '0 0 0 1 * ?', '2295908251@qq.com,2690574341@qq.com', '0', NULL, '青邮', '青邮receiveMailName', '1', NULL, '2023-10-26 20:12:14', NULL, '2023-10-26 20:12:14');
INSERT INTO `mail` VALUES (60, 5, '2295908251@qq.com', NULL, 'ysy独美的邮件', 'ysy独美的邮件正文', '0 0 2 1 * ?', '2295908251@qq.com', '1', 1, '青邮', '青邮receiveMailName', '1', NULL, '2023-10-28 20:27:33', NULL, '2023-10-28 20:27:33');
INSERT INTO `mail` VALUES (61, 5, '2295908251@qq.com', NULL, '上班提醒', '还有10分钟上班，抓紧时间了', '0 0 19 * * ?', '295908251@qq.com', '1', 0, '青邮', '青邮receiveMailName', '0', NULL, '2023-10-30 22:35:19', NULL, '2023-10-30 22:35:19');
INSERT INTO `mail` VALUES (62, 5, '2295908251@qq.com', NULL, '还有10分钟上班，抓紧时间了', '还有10分钟上班，抓紧时间了', '0 50 19 * * ?', '2295908251@qq.com', '1', 0, '青邮', '青邮receiveMailName', '0', NULL, '2023-10-30 22:36:04', NULL, '2023-10-30 22:36:04');
INSERT INTO `mail` VALUES (65, 5, '2295908251@qq.com', NULL, '牙牙和泽泽的每日提醒', '今天也要好好学习，早点休息，锻炼身体哦~~~', '0 0 8 * * ?', '2728771838@qq.com,2295908251@qq.com', '1', 1, '阿泽', '青邮', '0', NULL, '2023-11-02 22:32:26', NULL, '2023-11-02 22:32:26');
INSERT INTO `mail` VALUES (67, 5, '2295908251@qq.com', NULL, '我是一个模板标题3', '我是一个模板标题3', '0 0 0 * * ?', '2295908251@qq.com,189572094@qq.com,2690574341@qq.com', '1', 2, '青邮', '青邮', '1', NULL, '2023-11-04 09:21:22', NULL, '2023-11-04 09:21:22');
INSERT INTO `mail` VALUES (68, 3, '2728771838@qq.com', NULL, 'wzz', 'wzz', '0 26 10 * * ?', '2295908251@qq.com', '0', NULL, '小王', '青邮', '0', NULL, '2023-11-04 10:24:45', NULL, '2023-11-04 10:24:45');
COMMIT;

-- ----------------------------
-- Table structure for oauth_approvals
-- ----------------------------
DROP TABLE IF EXISTS `oauth_approvals`;
CREATE TABLE `oauth_approvals` (
  `userId` varchar(256) DEFAULT NULL,
  `clientId` varchar(256) DEFAULT NULL,
  `partnerKey` varchar(32) DEFAULT NULL,
  `scope` varchar(256) DEFAULT NULL,
  `status` varchar(10) DEFAULT NULL,
  `expiresAt` datetime DEFAULT NULL,
  `lastModifiedAt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of oauth_approvals
-- ----------------------------
BEGIN;
INSERT INTO `oauth_approvals` VALUES ('torlesse', 'torlesse002', NULL, 'TEST', 'APPROVED', '2022-05-13 17:19:25', '2022-04-13 17:19:25');
COMMIT;

-- ----------------------------
-- Table structure for oauth_client_details
-- ----------------------------
DROP TABLE IF EXISTS `oauth_client_details`;
CREATE TABLE `oauth_client_details` (
  `client_id` varchar(255) CHARACTER SET utf8 NOT NULL,
  `resource_ids` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `client_secret` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `scope` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `authorized_grant_types` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `web_server_redirect_uri` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `authorities` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `access_token_validity` int(11) DEFAULT NULL,
  `refresh_token_validity` int(11) DEFAULT NULL,
  `additional_information` varchar(4096) CHARACTER SET utf8 DEFAULT NULL,
  `autoapprove` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`client_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of oauth_client_details
-- ----------------------------
BEGIN;
INSERT INTO `oauth_client_details` VALUES ('torlesse000', 'torlesseservice', '123456', 'TEST', 'password,refresh_token', '', NULL, 7200, NULL, NULL, 'true');
INSERT INTO `oauth_client_details` VALUES ('torlesse001', 'torlesseservice', '123456', 'TEST', 'client_credentials,refresh_token', '', NULL, 7200, NULL, NULL, 'true');
INSERT INTO `oauth_client_details` VALUES ('torlesse002', 'torlesseservice', '123456', 'TEST', 'authorization_code,refresh_token', 'https://baidu.com,http://localhost:8083/torlesse/remoteCall,http://localhost:8083/torlesse/login,http://localhost:8082/torlesse/login', 'ROLE_ADMIN', 7200, NULL, NULL, 'false');
INSERT INTO `oauth_client_details` VALUES ('torlesse003', 'torlesseservice', NULL, 'TEST', 'implicit', 'https://baidu.com1', NULL, 7200, NULL, NULL, 'true');
INSERT INTO `oauth_client_details` VALUES ('torlesse004', 'torlesseservice', '123456', 'TEST', 'sms_code,refresh_token', NULL, NULL, 7200, NULL, NULL, 'true');
COMMIT;

-- ----------------------------
-- Table structure for oauth_code
-- ----------------------------
DROP TABLE IF EXISTS `oauth_code`;
CREATE TABLE `oauth_code` (
  `code` varchar(255) DEFAULT NULL,
  `authentication` blob
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of oauth_code
-- ----------------------------
BEGIN;
INSERT INTO `oauth_code` VALUES ('gvMF5X', 0xACED0005737200416F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E4F417574683241757468656E7469636174696F6EBD400B02166252130200024C000D73746F7265645265717565737474003C4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F70726F76696465722F4F4175746832526571756573743B4C00127573657241757468656E7469636174696F6E7400324C6F72672F737072696E676672616D65776F726B2F73656375726974792F636F72652F41757468656E7469636174696F6E3B787200476F72672E737072696E676672616D65776F726B2E73656375726974792E61757468656E7469636174696F6E2E416273747261637441757468656E7469636174696F6E546F6B656ED3AA287E6E47640E0200035A000D61757468656E746963617465644C000B617574686F7269746965737400164C6A6176612F7574696C2F436F6C6C656374696F6E3B4C000764657461696C737400124C6A6176612F6C616E672F4F626A6563743B787000737200266A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C654C697374FC0F2531B5EC8E100200014C00046C6973747400104C6A6176612F7574696C2F4C6973743B7872002C6A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65436F6C6C656374696F6E19420080CB5EF71E0200014C00016371007E00047870737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000002770400000002737200426F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E617574686F726974792E53696D706C654772616E746564417574686F72697479000000000000021C0200014C0004726F6C657400124C6A6176612F6C616E672F537472696E673B787074000A524F4C455F41444D494E7371007E000D74000A5858585F44454C4554457871007E000C707372003A6F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E4F41757468325265717565737400000000000000010200075A0008617070726F7665644C000B617574686F72697469657371007E00044C000A657874656E73696F6E7374000F4C6A6176612F7574696C2F4D61703B4C000B726564697265637455726971007E000E4C00077265667265736874003B4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F70726F76696465722F546F6B656E526571756573743B4C000B7265736F7572636549647374000F4C6A6176612F7574696C2F5365743B4C000D726573706F6E7365547970657371007E0016787200386F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E426173655265717565737436287A3EA37169BD0200034C0008636C69656E74496471007E000E4C001172657175657374506172616D657465727371007E00144C000573636F706571007E0016787074000B746F726C65737365303032737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C654D6170F1A5A8FE74F507420200014C00016D71007E00147870737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F400000000000067708000000080000000574000D726573706F6E73655F74797065740004636F646574000C72656469726563745F75726974001E687474703A2F2F6C6F63616C686F73743A383038332F75692F6C6F67696E74000573746174657400063441416C4E33740009636C69656E745F696471007E001974000573636F70657400045445535478737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65536574801D92D18F9B80550200007871007E0009737200176A6176612E7574696C2E4C696E6B656448617368536574D86CD75A95DD2A1E020000787200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000103F400000000000017400045445535478017371007E002A770C000000103F400000000000017371007E000D74000A524F4C455F41444D494E787371007E001C3F40000000000000770800000010000000007871007E0021707371007E002A770C000000103F4000000000000174000F746F726C6573736573657276696365787371007E002A770C000000103F4000000000000171007E001F787372004F6F72672E737072696E676672616D65776F726B2E73656375726974792E61757468656E7469636174696F6E2E557365726E616D6550617373776F726441757468656E7469636174696F6E546F6B656E000000000000021C0200024C000B63726564656E7469616C7371007E00054C00097072696E636970616C71007E00057871007E0003017371007E00077371007E000B0000000277040000000271007E000F71007E00117871007E0037737200486F72672E737072696E676672616D65776F726B2E73656375726974792E7765622E61757468656E7469636174696F6E2E57656241757468656E7469636174696F6E44657461696C73000000000000021C0200024C000D72656D6F74654164647265737371007E000E4C000973657373696F6E496471007E000E787074000F303A303A303A303A303A303A303A31740020343139303945314236354337363934443336353741463831303839304641463170737200326F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E7573657264657461696C732E55736572000000000000021C0200075A00116163636F756E744E6F6E457870697265645A00106163636F756E744E6F6E4C6F636B65645A001563726564656E7469616C734E6F6E457870697265645A0007656E61626C65644C000B617574686F72697469657371007E00164C000870617373776F726471007E000E4C0008757365726E616D6571007E000E7870010101017371007E0027737200116A6176612E7574696C2E54726565536574DD98509395ED875B0300007870737200466F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E7573657264657461696C732E5573657224417574686F72697479436F6D70617261746F72000000000000021C020000787077040000000271007E000F71007E00117870740008746F726C65737365);
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) DEFAULT NULL COMMENT '用户名',
  `password` varchar(64) DEFAULT NULL COMMENT '用户密码',
  `nickname` varchar(25) DEFAULT NULL COMMENT '用户昵称',
  `enabled` int(11) DEFAULT '1' COMMENT '默认1  1有效 0 无效',
  `img` varchar(255) DEFAULT NULL COMMENT '头像',
  `status` varchar(3) DEFAULT '0' COMMENT '0普通用户/1管理员',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` VALUES (1, 'zhangsan', '$2a$10$Tita.UN68cFI.UEE7Ivtp.FUUuzG/2Ivx1a2PJC8qCCUKBWUWcqcu', 'zhangsan', 1, NULL, '0');
INSERT INTO `t_user` VALUES (2, 'torlesse', '$2a$10$ekRqxzJusFABau5pPGXhcOZDy8ts9iwoL.bE6zkbMKWWjmA6./tUy', 'zhangsan', 1, NULL, '0');
INSERT INTO `t_user` VALUES (3, '2728771838@qq.com', '$2a$10$96fKK/WhzCFJyrTBjgRNKetl1rdBqL8KUUmToOoG4yUWGJ8DMeGRK', '2728771838@qq.com', 1, NULL, '0');
INSERT INTO `t_user` VALUES (4, '2295908252@qq.com', '$2a$10$jeSlMUToxcu8AkMUOiCNu.PpihHCOJ1DjuATg2xWKz9m/bznQY1Gq', '2295908252@qq.com', 1, NULL, '0');
INSERT INTO `t_user` VALUES (5, '2295908251@qq.com', '$2a$10$fXhl9r05ob6URrksCp2DwuZiB89Zn/3mlEmrPC3vJPw1cjyazLscW', '王泽政', 1, 'http://43.140.208.238:9000/test/2023-10-30/2023-10-30&&1698671396754.png', '0');
INSERT INTO `t_user` VALUES (6, '2690574341@qq.com', '$2a$10$Ub79pvV2JdKvrXjb/dRVLu.gG7g8ovj/YFMxIlzhio6cULy4Qkx4S', 'wzz的小号', 1, 'http://43.140.208.238:9000/test/2023-11-04/2023-11-04&&1699059071746.png', '0');
INSERT INTO `t_user` VALUES (7, '189572094@qq.com', '$2a$10$TqefLsnG7DTxezXzbcRqVuXFRxMU.B7/CbDBfbKqzgaejpPpaVBxy', 'wzz3', 1, NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for team_member
-- ----------------------------
DROP TABLE IF EXISTS `team_member`;
CREATE TABLE `team_member` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `team_id` bigint(20) DEFAULT NULL COMMENT '团队id',
  `member_id` bigint(20) DEFAULT NULL COMMENT '成员id',
  `is_manager` varchar(5) DEFAULT '0' COMMENT '是否是创建人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of team_member
-- ----------------------------
BEGIN;
INSERT INTO `team_member` VALUES (1, 1, 3, '1');
INSERT INTO `team_member` VALUES (2, 2, 5, '1');
INSERT INTO `team_member` VALUES (4, 1, 5, '0');
INSERT INTO `team_member` VALUES (5, 3, 5, '1');
INSERT INTO `team_member` VALUES (6, 2, 7, '0');
INSERT INTO `team_member` VALUES (7, 4, 3, '1');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
